﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_MemberRank') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_MemberRank
END
GO
create view V_MemberRank
as select 
[Guid]
,[Name]
,[Discount]
from [ShopNum1_MemberRank] where IsDeleted=0